<!DOCTYPE html>
<!-- Generated by pkgdown: do not edit by hand --><html lang="en"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><meta charset="utf-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"><title>statestats_query - convenient way to see mean, pctiles of Env or Demog indicators from lookup table — statestats_query • EJAM</title><!-- favicons --><link rel="icon" type="image/png" sizes="16x16" href="../favicon-16x16.png"><link rel="icon" type="image/png" sizes="32x32" href="../favicon-32x32.png"><link rel="apple-touch-icon" type="image/png" sizes="180x180" href="../apple-touch-icon.png"><link rel="apple-touch-icon" type="image/png" sizes="120x120" href="../apple-touch-icon-120x120.png"><link rel="apple-touch-icon" type="image/png" sizes="76x76" href="../apple-touch-icon-76x76.png"><link rel="apple-touch-icon" type="image/png" sizes="60x60" href="../apple-touch-icon-60x60.png"><script src="../deps/jquery-3.6.0/jquery-3.6.0.min.js"></script><meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"><link href="../deps/bootstrap-5.3.1/bootstrap.min.css" rel="stylesheet"><script src="../deps/bootstrap-5.3.1/bootstrap.bundle.min.js"></script><link href="../deps/font-awesome-6.4.2/css/all.min.css" rel="stylesheet"><link href="../deps/font-awesome-6.4.2/css/v4-shims.min.css" rel="stylesheet"><script src="../deps/headroom-0.11.0/headroom.min.js"></script><script src="../deps/headroom-0.11.0/jQuery.headroom.min.js"></script><script src="../deps/bootstrap-toc-1.0.1/bootstrap-toc.min.js"></script><script src="../deps/clipboard.js-2.0.11/clipboard.min.js"></script><script src="../deps/search-1.0.0/autocomplete.jquery.min.js"></script><script src="../deps/search-1.0.0/fuse.min.js"></script><script src="../deps/search-1.0.0/mark.min.js"></script><!-- pkgdown --><script src="../pkgdown.js"></script><meta property="og:title" content="statestats_query - convenient way to see mean, pctiles of Env or Demog indicators from lookup table — statestats_query"><meta name="description" content="statestats_query - convenient way to see mean, pctiles of Env or Demog indicators from lookup table"><meta property="og:description" content="statestats_query - convenient way to see mean, pctiles of Env or Demog indicators from lookup table"><meta property="og:image" content="https://usepa.github.io/EJAM/logo.svg"></head><body>
    <a href="#main" class="visually-hidden-focusable">Skip to contents</a>


    <nav class="navbar navbar-expand-lg fixed-top bg-light" data-bs-theme="light" aria-label="Site navigation"><div class="container">

    <a class="navbar-brand me-2" href="../index.html">EJAM</a>

    <small class="nav-text text-warning me-auto" data-bs-toggle="tooltip" data-bs-placement="bottom" title="Released version">2.32.0</small>


    <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbar" aria-controls="navbar" aria-expanded="false" aria-label="Toggle navigation">
      <span class="navbar-toggler-icon"></span>
    </button>

    <div id="navbar" class="collapse navbar-collapse ms-3">
      <ul class="navbar-nav me-auto"><li class="active nav-item"><a class="nav-link" href="../reference/index.html">Reference</a></li>
<li class="nav-item dropdown">
  <button class="nav-link dropdown-toggle" type="button" id="dropdown-articles" data-bs-toggle="dropdown" aria-expanded="false" aria-haspopup="true">Articles</button>
  <ul class="dropdown-menu" aria-labelledby="dropdown-articles"><li><hr class="dropdown-divider"></li>
    <li><h6 class="dropdown-header" data-toc-skip>Overview for EJAM Users</h6></li>
    <li><a class="dropdown-item" href="../articles/0_whatis.html">What is EJAM</a></li>
    <li><a class="dropdown-item" href="../articles/0_webapp.html">Using EJAM</a></li>
    <li><hr class="dropdown-divider"></li>
    <li><h6 class="dropdown-header" data-toc-skip>For analysts using R</h6></li>
    <li><a class="dropdown-item" href="../articles/1_installing.html">Installing the EJAM R package</a></li>
    <li><a class="dropdown-item" href="../articles/2_quickstart.html">Quick Start Guide</a></li>
    <li><a class="dropdown-item" href="../articles/3_analyzing.html">Basics of Using EJAM for Analysis in RStudio</a></li>
    <li><a class="dropdown-item" href="../articles/4_advanced.html">Advanced Features</a></li>
  </ul></li>
<li class="nav-item"><a class="nav-link" href="../news/index.html">Changelog</a></li>
      </ul><ul class="navbar-nav"><li class="nav-item"><form class="form-inline" role="search">
 <input class="form-control" type="search" name="search-input" id="search-input" autocomplete="off" aria-label="Search site" placeholder="Search for" data-search-index="../search.json"></form></li>
<li class="nav-item"><a class="external-link nav-link" href="https://github.com/USEPA/EJAM/" aria-label="GitHub"><span class="fa fab fa-github fa-lg"></span></a></li>
      </ul></div>


  </div>
</nav><div class="container template-reference-topic">
<div class="row">
  <main id="main" class="col-md-9"><div class="page-header">
      <img src="../logo.svg" class="logo" alt=""><h1>statestats_query - convenient way to see mean, pctiles of Env or Demog indicators from lookup table</h1>
      <small class="dont-index">Source: <a href="https://github.com/USEPA/EJAM/blob/HEAD/R/statestats_query.R" class="external-link"><code>R/statestats_query.R</code></a></small>
      <div class="d-none name"><code>statestats_query.Rd</code></div>
    </div>

    <div class="ref-description section level2">
    <p>statestats_query - convenient way to see mean, pctiles of Env or Demog indicators from lookup table</p>
    </div>

    <div class="section level2">
    <h2 id="ref-usage">Usage<a class="anchor" aria-label="anchor" href="#ref-usage"></a></h2>
    <div class="sourceCode"><pre class="sourceCode r"><code><span><span class="fu">statestats_query</span><span class="op">(</span></span>
<span>  ST <span class="op">=</span> <span class="fu"><a href="https://rdrr.io/r/base/sort.html" class="external-link">sort</a></span><span class="op">(</span><span class="fu"><a href="https://rdrr.io/r/base/unique.html" class="external-link">unique</a></span><span class="op">(</span><span class="fu">EJAM</span><span class="fu">::</span><span class="va"><a href="statestats.html">statestats</a></span><span class="op">$</span><span class="va">REGION</span><span class="op">)</span><span class="op">)</span>,</span>
<span>  varnames <span class="op">=</span> <span class="fu"><a href="https://rdrr.io/r/base/c.html" class="external-link">c</a></span><span class="op">(</span><span class="fu">EJAM</span><span class="fu">::</span><span class="va"><a href="names_e.html">names_e</a></span>, <span class="fu">EJAM</span><span class="fu">::</span><span class="va"><a href="names_d.html">names_d</a></span><span class="op">)</span>,</span>
<span>  PCTILES <span class="op">=</span> <span class="cn">NULL</span>,</span>
<span>  dig <span class="op">=</span> <span class="fl">3</span></span>
<span><span class="op">)</span></span></code></pre></div>
    </div>

    <div class="section level2">
    <h2 id="arguments">Arguments<a class="anchor" aria-label="anchor" href="#arguments"></a></h2>


<dl><dt id="arg-st">ST<a class="anchor" aria-label="anchor" href="#arg-st"></a></dt>
<dd><p>vector of state abbreviations, or USA</p></dd>


<dt id="arg-varnames">varnames<a class="anchor" aria-label="anchor" href="#arg-varnames"></a></dt>
<dd><p>names of columns in lookup table, like "proximity.rmp"</p></dd>


<dt id="arg-pctiles">PCTILES<a class="anchor" aria-label="anchor" href="#arg-pctiles"></a></dt>
<dd><p>vector of percentiles 0-100 and/or "mean"</p></dd>


<dt id="arg-dig">dig<a class="anchor" aria-label="anchor" href="#arg-dig"></a></dt>
<dd><p>digits to round to</p></dd>

</dl></div>

    <div class="section level2">
    <h2 id="ref-examples">Examples<a class="anchor" aria-label="anchor" href="#ref-examples"></a></h2>
    <div class="sourceCode"><pre class="sourceCode r"><code><span><span class="kw">if</span> <span class="op">(</span><span class="cn">FALSE</span><span class="op">)</span> <span class="op">{</span> <span class="co"># \dontrun{</span></span>
<span></span>
<span><span class="fu"><a href="usastats_querye.html">usastats_querye</a></span><span class="op">(</span><span class="op">)</span> </span>
<span><span class="co">#  data.frame where names_e are the names(), </span></span>
<span><span class="co">#  means plus other percentiles, and there are other cols REGION PCTILE</span></span>
<span></span>
<span><span class="va">avg.in.us</span>                <span class="co"># This is a data.frame, 1 row, where colnames are indicators</span></span>
<span><span class="va">avg.in.us</span><span class="op">[</span><span class="va">names_e</span><span class="op">]</span>          <span class="co"># subset is a data.frame!</span></span>
<span><span class="fu"><a href="https://rdrr.io/r/base/unlist.html" class="external-link">unlist</a></span><span class="op">(</span><span class="va">avg.in.us</span><span class="op">[</span><span class="va">names_e</span><span class="op">]</span><span class="op">)</span>  <span class="co"># to make it a vector</span></span>
<span></span>
<span><span class="fu"><a href="usastats_means.html">usastats_means</a></span><span class="op">(</span><span class="op">)</span>        <span class="co"># This is a matrix, with 1 col, and indicator names are rownames</span></span>
<span><span class="fu"><a href="usastats_means.html">usastats_means</a></span><span class="op">(</span><span class="va">names_e</span><span class="op">)</span>     <span class="co"># subset is a matrix        and indicator names are rownames</span></span>
<span><span class="fu"><a href="usastats_means.html">usastats_means</a></span><span class="op">(</span><span class="op">)</span><span class="op">[</span><span class="va">names_e</span>, <span class="op">]</span> <span class="co"># subset is a named vector  and indicator names are  names</span></span>
<span></span>
<span><span class="fu"><a href="usastats_means.html">usastats_means</a></span><span class="op">(</span><span class="op">)</span></span>
<span><span class="fu">statestats_query</span><span class="op">(</span><span class="op">)</span></span>
<span></span>
<span><span class="fu">statestats_query</span><span class="op">(</span><span class="op">)</span><span class="op">[</span>,<span class="va">names_d</span><span class="op">]</span></span>
<span><span class="fu">statestats_query</span><span class="op">(</span>varnames <span class="op">=</span> <span class="va">names_d</span><span class="op">)</span></span>
<span></span>
<span><span class="fu">statestats_query</span><span class="op">(</span><span class="op">)</span><span class="op">[</span>,<span class="va">names_e</span><span class="op">]</span></span>
<span><span class="fu">statestats_query</span><span class="op">(</span>varnames <span class="op">=</span> <span class="va">names_e</span><span class="op">)</span></span>
<span></span>
<span><span class="fu">statestats_query</span><span class="op">(</span>varnames <span class="op">=</span> <span class="va">names_d_subgroups</span><span class="op">)</span></span>
<span><span class="fu"><a href="https://rdrr.io/r/utils/head.html" class="external-link">head</a></span><span class="op">(</span><span class="fu">statestats_query</span><span class="op">(</span>varnames <span class="op">=</span> <span class="va">longlist</span><span class="op">)</span><span class="op">)</span></span>
<span></span>
<span><span class="co">## in USA overall, see mean and key percentiles</span></span>
<span><span class="co"># for all demog and envt indicators</span></span>
<span><span class="fu"><a href="usastats_query.html">usastats_query</a></span><span class="op">(</span><span class="op">)</span> <span class="co"># or statestats_query('us') </span></span>
<span><span class="co"># can say us or US or USA or usa etc.</span></span>
<span><span class="fu"><a href="usastats_query.html">usastats_query</a></span><span class="op">(</span>PCTILES <span class="op">=</span> <span class="st">'mean'</span><span class="op">)</span></span>
<span><span class="fu"><a href="usastats_means.html">usastats_means</a></span><span class="op">(</span><span class="op">)</span> <span class="co"># same but nicer looking format in console</span></span>
<span><span class="fu"><a href="usastats_means.html">usastats_means</a></span><span class="op">(</span>dig<span class="op">=</span><span class="fl">4</span><span class="op">)</span></span>
<span></span>
<span><span class="co"># long list of variables:</span></span>
<span><span class="va">x</span> <span class="op">=</span> <span class="fu"><a href="https://rdrr.io/r/base/sets.html" class="external-link">intersect</a></span><span class="op">(</span><span class="fu">EJAM</span><span class="fu">::</span><span class="va"><a href="names_all_r.html">names_all_r</a></span>,  <span class="fu"><a href="https://rdrr.io/r/base/names.html" class="external-link">names</a></span><span class="op">(</span><span class="fu">EJAM</span><span class="fu">::</span><span class="va"><a href="usastats.html">usastats</a></span><span class="op">)</span><span class="op">)</span></span>
<span><span class="fu"><a href="usastats_means.html">usastats_means</a></span><span class="op">(</span><span class="va">x</span><span class="op">)</span></span>
<span></span>
<span><span class="va">usastats</span><span class="op">[</span><span class="op">!</span><span class="op">(</span><span class="va">usastats</span><span class="op">$</span><span class="va">PCTILE</span> <span class="op">&lt;</span> <span class="fl">50</span><span class="op">)</span>, <span class="fu"><a href="https://rdrr.io/r/base/c.html" class="external-link">c</a></span><span class="op">(</span><span class="st">"PCTILE"</span>, <span class="va">names_d</span><span class="op">)</span><span class="op">]</span></span>
<span><span class="va">usastats</span><span class="op">[</span><span class="op">!</span><span class="op">(</span><span class="va">usastats</span><span class="op">$</span><span class="va">PCTILE</span> <span class="op">&lt;</span> <span class="fl">50</span><span class="op">)</span>, <span class="fu"><a href="https://rdrr.io/r/base/c.html" class="external-link">c</a></span><span class="op">(</span><span class="st">"PCTILE"</span>, <span class="va">names_e</span><span class="op">)</span><span class="op">]</span></span>
<span></span>
<span><span class="co">## in 1 state, see mean and key percentiles for all demog and envt indicators</span></span>
<span><span class="fu">statestats_query</span><span class="op">(</span><span class="st">'MD'</span><span class="op">)</span></span>
<span></span>
<span><span class="co">## in 1 state, see mean and key percentiles for just demog indicators</span></span>
<span><span class="fu"><a href="statestats_queryd.html">statestats_queryd</a></span><span class="op">(</span><span class="st">'MD'</span><span class="op">)</span></span>
<span></span>
<span><span class="co">## 1 indicator in 1 state, see a few key percentiles and mean</span></span>
<span><span class="fu">statestats_query</span><span class="op">(</span><span class="st">'MD'</span>,<span class="st">'proximity.tsdf'</span><span class="op">)</span></span>
<span></span>
<span><span class="co">## mean of 1 indicator for each state</span></span>
<span><span class="fu">statestats_query</span><span class="op">(</span>varnames <span class="op">=</span> <span class="st">'proximity.tsdf'</span><span class="op">)</span></span>
<span></span>
<span><span class="co">## using full blockgroup dataset, not lookup tables of percentiles, </span></span>
<span><span class="va">blockgroupstats</span><span class="op">[</span>, <span class="fu"><a href="https://rdrr.io/r/base/lapply.html" class="external-link">lapply</a></span><span class="op">(</span><span class="va">.SD</span>, <span class="kw">function</span><span class="op">(</span><span class="va">x</span><span class="op">)</span> <span class="fu"><a href="https://rdrr.io/r/base/mean.html" class="external-link">mean</a></span><span class="op">(</span><span class="va">x</span>, na.rm<span class="op">=</span><span class="cn">T</span><span class="op">)</span><span class="op">)</span>,</span>
<span>   .SDcols<span class="op">=</span> <span class="fu"><a href="https://rdrr.io/r/base/c.html" class="external-link">c</a></span><span class="op">(</span><span class="va">names_d</span>, <span class="va">names_e</span><span class="op">)</span><span class="op">]</span></span>
<span></span>
<span><span class="co">##   see all total counts (not just US means), </span></span>
<span><span class="co">##   demographics including subgroups, </span></span>
<span><span class="co">##   but not environmental indicators.</span></span>
<span><span class="fu"><a href="https://rdrr.io/r/base/t.html" class="external-link">t</a></span><span class="op">(</span><span class="va">blockgroupstats</span><span class="op">[</span>, <span class="fu"><a href="https://rdrr.io/r/base/lapply.html" class="external-link">lapply</a></span><span class="op">(</span><span class="va">.SD</span>, <span class="kw">function</span><span class="op">(</span><span class="va">x</span><span class="op">)</span> <span class="fu"><a href="https://rdrr.io/r/base/mean.html" class="external-link">mean</a></span><span class="op">(</span><span class="va">x</span>, na.rm<span class="op">=</span><span class="cn">T</span><span class="op">)</span><span class="op">)</span>,</span>
<span>    .SDcols<span class="op">=</span> <span class="fu"><a href="https://rdrr.io/r/base/c.html" class="external-link">c</a></span><span class="op">(</span><span class="va">names_e</span>, <span class="va">names_d</span><span class="op">)</span><span class="op">]</span><span class="op">)</span></span>
<span></span>
<span><span class="op">}</span> <span class="co"># }</span></span>
<span></span></code></pre></div>
    </div>
  </main><aside class="col-md-3"><nav id="toc" aria-label="Table of contents"><h2>On this page</h2>
    </nav></aside></div>


    <footer><div class="pkgdown-footer-left">
  <p>US EPA 2024</p>
</div>

<div class="pkgdown-footer-right">
  <p>EJAM Version 2.32.0</p>
</div>

    </footer></div>





  </body></html>

